package com.beyond.trace.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.beyond.trace.domain.TraceScanStatistics;
import com.beyond.trace.domain.vo.ScanProductCountVo;
import com.beyond.trace.domain.vo.ScanProvinceCountVo;
import com.beyond.trace.domain.vo.ScanSevenDaysCountVo;
import com.beyond.trace.domain.vo.ScanStatisticsVo;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * 扫码统计;(t_trace_scan_statistics)表数据库访问层
 * @author : zq
 * @date : 2023-1-6
 */
@Mapper
public interface TraceScanStatisticsMapper  extends BaseMapper<TraceScanStatistics> {

    /*首页顶部扫码统计*/
    public ScanStatisticsVo getScanStatistics();

    /*查询近七天的扫码统计*/
    public List<ScanSevenDaysCountVo> selectSevenDaysCount();

    /*统计所有正常扫码数量*/
    public Integer countAll();

    /*扫码省份统计*/
    public List<ScanProvinceCountVo> provinceCount();

    /*查询最新十条数据*/
    public List<TraceScanStatistics> selectTenStrip();

    /*查询本周每日统计*/
    public List<ScanSevenDaysCountVo> thisWeekCountList();

    List<ScanProductCountVo> groupProduct();
}
